Interview Questions

1. You are developing a SQL Server Integration Services (SSIS) package to load data into a SQL Server table on Server A. The package includes a data flow and is executed on Server B. The destination table has its own identity column. The destination data load has the following requirements: ?1. The identity values from the source table must be used.?2. Default constraints on the destination table must be ignored.?3. Batch size must be 100,000 rows. You need to add a destination and configure it to meet the requirements. Which destination should you use?

Options:

a. OLE DB Destination with Fast Load.

b. ADO NET Destination without Bulk Insert.

c. OLE DB Destination without Fast Load.

d. SQL Server Destination.

Reveal Answer

2. How many types of SSIS connection managers are there?

Options:

a. 4

b. 5

c. 6

d. 19

Reveal Answer

3. You are creating a SQL Server 2008 Integration Services (SSIS) data flow which moves information to a SQL Server 2008 database for Company.com. You should make sure that data flow refreshes the existed data in the SQL Server database through utilizing data in your data flow. Which is the correct answer?

Options:

a. You should utilize Data Conversion Transformation

b. You should utilize SQL Server Destination

c. You should utilize OLE DB Destination

d. You should utilize Dynamic Management View (DMV)

Reveal Answer

4. What does a control flow do?

Options:

a. To control workflow

b. To control events

c. To control data flows.

d. To control lookup

Reveal Answer

5. SSIS 2008 configuration types?

Options:

a. Five

b. Four

c. Three

d. One

Reveal Answer

6. Which section of your package manages the overall process flow for the entire package?

Options:

a. Data Flow

b. Connection Manager

c. Control Flow

d. Package Explorer

Reveal Answer

7. Which of the following Data Flow tasks require that the data be sorted prior to their execution?

Options:

a. Pivot

b. Merge Join

c. Conditional Split

d. Pivot & Merge Join

Reveal Answer

8. Which of the following is not a valid Evaluation Operator for a Precedence Constraint?

Options:

a. Expression

b. Constraint

c. Variable

d. Expression or Constraint

Reveal Answer

9. Which Data Flow Destination would be the most appropriate for sending a quick dump of data to a customer?

Options:

a. Raw File

b. OLE DB

c. Recordset

d. Excel

Reveal Answer

10. Database maintenance tasks can be performed directly in SSIS packages.

Options:

a. True

b. False

Reveal Answer

11. Which of the following is not an option when configuring Error Outputs on Data Flow Tasks?

Options:

a. Fail Component

b. Ignore Failure

c. Redirect Row

d. Log Failure

Reveal Answer

12. You can use Expression to set the values of SSIS variables?

Options:

a. True

b. False

Reveal Answer

13. Which of the following is only available as a Data Flow Destination and not a source?

Options:

a. Excel

b. Raw File

c. OLE DB

d. Recordset

Reveal Answer

Interview Questions and Answer

2. How many types of SSIS connection managers are there?

4. What does a control flow do?

5. SSIS 2008 configuration types?

6. Which section of your package manages the overall process flow for the entire package?

7. Which of the following Data Flow tasks require that the data be sorted prior to their execution?

8. Which of the following is not a valid Evaluation Operator for a Precedence Constraint?

9. Which Data Flow Destination would be the most appropriate for sending a quick dump of data to a customer?

10. Database maintenance tasks can be performed directly in SSIS packages.

11. Which of the following is not an option when configuring Error Outputs on Data Flow Tasks?

12. You can use Expression to set the values of SSIS variables?

13. Which of the following is only available as a Data Flow Destination and not a source?

Packages

Trending Certification Courses:

Microsoft Mock Exams:

Other links

About

Resources